package team.hyznrj.studentsys.dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import team.hyznrj.studentsys.entity.QualityAchievement;
import team.hyznrj.studentsys.entity.QualityAchievementExample;
import team.hyznrj.studentsys.entity.QualityAchievementKey;
import team.hyznrj.studentsys.entity.SimpleQualityEntity;

public interface QualityAchievementMapper {
	/**
	 * 自定义接口:
	 * <p>
	 * SELECT SNO,SUM(VALUE) AS VALUE,ACADEMIC_YEARS,ITEM,FLAG,PROJECT_TYPE FROM
	 * QUALITY_ACHIEVEMENT <if test="_parameter != null">
	 * <include refid="Example_Where_Clause" /> </if> GROUP BY
	 * ACADEMIC_YEARS,ITEM,PROJECT_TYPE;
	 * </p>
	 * 2018年7月31日添加
	 * 
	 * @param example
	 * @return
	 */
	List<SimpleQualityEntity> selectBySimple(QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int countByExample(QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int deleteByExample(QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int deleteByPrimaryKey(QualityAchievementKey key);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int insert(QualityAchievement record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int insertSelective(QualityAchievement record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	List<QualityAchievement> selectByExample(QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	QualityAchievement selectByPrimaryKey(QualityAchievementKey key);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int updateByExampleSelective(@Param("record") QualityAchievement record,
			@Param("example") QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int updateByExample(@Param("record") QualityAchievement record,
			@Param("example") QualityAchievementExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int updateByPrimaryKeySelective(QualityAchievement record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds
	 * to the database table quality_achievement
	 *
	 * @mbggenerated Tue Jul 31 14:04:52 CST 2018
	 */
	int updateByPrimaryKey(QualityAchievement record);
}